Returns a value converted to a number.
Syntax
N(value)
Value is the value you want converted. N converts values listed in the following table.
If value is or refers to | N returns |
---|---|
A number | That number |
A date, in one of the built-in date formats available in Microsoft Excel | The serial number of that date |
TRUE | 1 |
FALSE | 0 |
An error value, such as #DIV/0! | The error value |
Anything else | 0 |
Example
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|